{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Workflow","Workflow Externe","Config","Generator"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":40,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Workflow","index":0,"n_rows":17,"n_cols":136,"rows_kept":17,"cut":false,"hidden":false,"merged":[[12,6,14,6],[12,19,14,19],[1,31,1,134],[12,111,12,119],[13,51,13,60],[4,3,4,14],[12,91,12,99],[12,81,12,89],[12,71,12,79],[12,61,12,69],[12,51,12,59],[12,41,12,49],[12,31,12,39],[13,31,13,40],[4,1,4,2],[13,81,13,90],[12,134,14,134],[12,5,14,5],[12,4,14,4],[12,3,14,3],[12,18,14,18],[12,8,14,8],[12,7,14,7],[12,2,14,2],[12,1,14,1],[12,20,14,20],[13,111,13,120],[12,15,14,15],[12,101,12,109],[12,121,12,129],[13,61,13,70],[13,91,13,100],[13,41,13,50],[13,121,13,130],[1,22,1,30],[2,22,2,30],[13,101,13,110],[13,71,13,80],[12,14,14,14],[12,17,14,17],[12,16,14,16],[12,22,13,30],[12,9,14,9],[12,10,14,10],[12,11,14,11],[12,12,14,12],[12,13,14,13]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"${markup}"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WORKFLOW REGISTER",null,null,null,null,null,null,null,null,"DETAILS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STATIC PROJECT NAME"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2022-11-20"},null,null,null,{"$f":"IF(StatusKeyToDo=\"Undefined\",\"\",StatusKeyToDo)","v":"To do"},{"$f":"IF(StatusToDo=\"Undefined\",\"\",StatusToDo)","v":"Task open"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Made with passion by Cooperlink",null,null,null,{"$f":"IF(StatusKey1=\"Undefined\",\"\",StatusKey1)","v":"A"},{"$f":"IF(StatusKey1=\"Undefined\",\"\",Status1)","v":"Approved"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(StatusKey2=\"Undefined\",\"\",StatusKey2)","v":"B"},{"$f":"IF(StatusKey2=\"Undefined\",\"\",Status2)","v":"Approved with comments"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(StatusKey3=\"Undefined\",\"\",StatusKey3)","v":"C"},{"$f":"IF(StatusKey3=\"Undefined\",\"\",Status3)","v":"Refuses"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(StatusKey4=\"Undefined\",\"\",StatusKey4)","v":"D"},{"$f":"IF(StatusKey4=\"Undefined\",\"\",Status4)","v":"Non concerned"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(StatusKey5=\"Undefined\",\"\",StatusKey5)","v":""},{"$f":"IF(StatusKey5=\"Undefined\",\"\",Status5)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(StatusKey6=\"Undefined\",\"\",StatusKey6)","v":""},{"$f":"IF(StatusKey6=\"Undefined\",\"\",Status6)","v":""}]
[]
[null,"PROJECT","TYPE","DISCIPLINE","NUMBER","REVISION","MANUFACTURER","SUPPLIER","PRODUCT","REF. SPECIFICATIONS","CONFORMITY","SAMPLE","FINANCIAL IMPACT","PLAN","ANNEXES","WORKFLOW\nTEMPLATE","WORKFLOW\nNAME","FILENAME","TITLE","DESCRIPTION","LINK ON COOPERLINK",null,"TRANSMISSION\n(WORKFLOW INTERNE)",null,null,null,null,null,null,null,null,{"$f":"UPPER(\"Architect\")","v":"ARCHITECT"},null,null,null,null,null,null,null,null,{"$f":"UPPER(\"ar\")","v":"AR"},{"$f":"UPPER(\"Stability\")","v":"STABILITY"},null,null,null,null,null,null,null,null,{"$f":"UPPER(\"stab\")","v":"STAB"},{"$f":"UPPER(\"MEP\")","v":"MEP"},null,null,null,null,null,null,null,null,{"$f":"UPPER(\"mpe\")","v":"MPE"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(\"Developer\")","v":"DEVELOPER"},null,null,null,null,null,null,null,null,{"$f":"UPPER(\"pm\")","v":"PM"},null,null,null,"COMMENTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"UPPER(\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"UPPER(\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DATE","DELAY\n PHASE 1","DELAY\nPHASE 2","THEORETICAL DUE DATE","CURRENT STEP","COMPLETED STATUS","LIFE STATUS","STATUS","APPROV. DATE",{"$f":"UPPER(Contribute&CHAR(10)&\"ar\")","v":"CONTRIB.\nAR"},{"$f":"UPPER(Assigned&CHAR(10)&\"ar\"&\" - CL\")","v":"ASSINGED\nAR - CL"},{"$f":"UPPER(Status&CHAR(10)&\"ar\"&\" - CL\")","v":"STATUS\nAR - CL"},{"$f":"UPPER(Comment&CHAR(10)&\"ar\"&\" - CL\")","v":"COMMENT.\nAR - CL"},{"$f":"UPPER(Attachment&CHAR(10)&\"ar\"&\" - CL\")","v":"ATTACH.\nAR - CL"},{"$f":"UPPER(Deadline&CHAR(10)&\"ar\"&\" - CL\")","v":"DUE DATE\nAR - CL"},{"$f":"UPPER(ApprovalDate&CHAR(10)&\"ar\"&\" - CL\")","v":"APPROVAL DATE\nAR - CL"},{"$f":"UPPER(Status&CHAR(10)&\"ar\")","v":"STATUS\nAR"},{"$f":"UPPER(ApprovalDate&CHAR(10)&\"ar\")","v":"APPROVAL DATE\nAR"},{"$f":"UPPER(Delay&CHAR(10)&\"Approb \"&CHAR(10)&\"ar\")","v":"DELAY\nAPPROB \nAR"},{"$f":"UPPER(Contribute&CHAR(10)&\"stab\")","v":"CONTRIB.\nSTAB"},{"$f":"UPPER(Assigned&CHAR(10)&\"stab\"&\" - CL\")","v":"ASSINGED\nSTAB - CL"},{"$f":"UPPER(Status&CHAR(10)&\"stab\"&\" - CL\")","v":"STATUS\nSTAB - CL"},{"$f":"UPPER(Comment&CHAR(10)&\"stab\"&\" - CL\")","v":"COMMENT.\nSTAB - CL"},{"$f":"UPPER(Attachment&CHAR(10)&\"stab\"&\" - CL\")","v":"ATTACH.\nSTAB - CL"},{"$f":"UPPER(Deadline&CHAR(10)&\"stab\"&\" - CL\")","v":"DUE DATE\nSTAB - CL"},{"$f":"UPPER(ApprovalDate&CHAR(10)&\"stab\"&\" - CL\")","v":"APPROVAL DATE\nSTAB - CL"},{"$f":"UPPER(Status&CHAR(10)&\"stab\")","v":"STATUS\nSTAB"},{"$f":"UPPER(ApprovalDate&CHAR(10)&\"stab\")","v":"APPROVAL DATE\nSTAB"},{"$f":"UPPER(Delay&CHAR(10)&\"Approb \"&CHAR(10)&\"stab\")","v":"DELAY\nAPPROB \nSTAB"},{"$f":"UPPER(Contribute&CHAR(10)&\"mpe\")","v":"CONTRIB.\nMPE"},{"$f":"UPPER(Assigned&CHAR(10)&\"mpe\"&\" - CL\")","v":"ASSINGED\nMPE - CL"},{"$f":"UPPER(Status&CHAR(10)&\"mpe\"&\" - CL\")","v":"STATUS\nMPE - CL"},{"$f":"UPPER(Comment&CHAR(10)&\"mpe\"&\" - CL\")","v":"COMMENT.\nMPE - CL"},{"$f":"UPPER(Attachment&CHAR(10)&\"mpe\"&\" - CL\")","v":"ATTACH.\nMPE - CL"},{"$f":"UPPER(Deadline&CHAR(10)&\"mpe\"&\" - CL\")","v":"DUE DATE\nMPE - CL"},{"$f":"UPPER(ApprovalDate&CHAR(10)&\"mpe\"&\" - CL\")","v":"APPROVAL DATE\nMPE - CL"},{"$f":"UPPER(Status&CHAR(10)&\"mpe\")","v":"STATUS\nMPE"},{"$f":"UPPER(ApprovalDate&CHAR(10)&\"mpe\")","v":"APPROVAL DATE\nMPE"},{"$f":"UPPER(Delay&CHAR(10)&\"Approb \"&CHAR(10)&\"mpe\")","v":"DELAY\nAPPROB \nMPE"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(Contribute&CHAR(10)&\"pm\")","v":"CONTRIB.\nPM"},{"$f":"UPPER(Assigned&CHAR(10)&\"pm\"&\" - CL\")","v":"ASSINGED\nPM - CL"},{"$f":"UPPER(Status&CHAR(10)&\"pm\"&\" - CL\")","v":"STATUS\nPM - CL"},{"$f":"UPPER(Comment&CHAR(10)&\"pm\"&\" - CL\")","v":"COMMENT.\nPM - CL"},{"$f":"UPPER(Attachment&CHAR(10)&\"pm\"&\" - CL\")","v":"ATTACH.\nPM - CL"},{"$f":"UPPER(Deadline&CHAR(10)&\"pm\"&\" - CL\")","v":"DUE DATE\nPM - CL"},{"$f":"UPPER(ApprovalDate&CHAR(10)&\"pm\"&\" - CL\")","v":"APPROVAL DATE\nPM - CL"},{"$f":"UPPER(Status&CHAR(10)&\"pm\")","v":"STATUS\nPM"},{"$f":"UPPER(ApprovalDate&CHAR(10)&\"pm\")","v":"APPROVAL DATE\nPM"},{"$f":"UPPER(Delay&CHAR(10)&\"Approb \"&CHAR(10)&\"pm\")","v":"DELAY\nAPPROB \nPM"},null,"Count Comments","Count attachments"]
[null,"MIDI","${company_project_document_type}","${company_project_package}","${company_project_number}","${company_project_revision}","${company_project_manufacturer}","${company_project_supplier}","${company_project_product}","${company_project_reference_specifications}","${company_project_conformity:label}","${company_project_sample:label}","${company_project_financial_impact:label}","${company_project_building_level}",{"$f":"TEXT(V16,\"000\")&TEXT(W16,\"000\")","v":"${locallink}${startdate}"},"${design_label}","${name}","${target.name}","${company_project_title}","${company_project_description}",{"$f":"HYPERLINK(V16,Link)","v":"Link"},"${locallink}","${startdate}","${company_project_delay_phase1}","${company_project_delay_phase2}",{"$f":"WORKDAY(W16,X16+Y16)","v":{"$error":"#VALUE!"}},"${current_step}","${completed_status}","${life_status}",{"$f":"IFERROR(IF(AC16=\"Current\",Current,Previous)&\" - \",\"\")&IFERROR(IF(AND(AB16=\"POSITIVE\",AC16=\"CURRENT\"),\"APPROUVÉ\",IF(AB16=\"NONE\",\"EN COURS - \"&AA16,IF(AB16=\"NEGATIVE\",\"REFUSÉ\",IF(AB16=\"ABORTED\",\"ARRETÉ\",\"\")))),\"\")","v":"Obsolete - "},{"$f":"IF(OR(AB16=\"POSITIVE\",AB16=\"NEGATIVE\"),MAX(AN16,AX16,BH16,BR16,CB16,CL16,CV16,DF16,DZ16),\"\")","v":""},{"$f":"IF(AG16<>\"\",\"X\",\"\")","v":"X"},"${company_project_ar}","${actions.company_project_action_ar.company_project_answer}","${actions.company_project_action_ar.company_project_comment}","${actions.company_project_action_ar.attachment_count}","${actions.company_project_action_ar.due_date}","${actions.company_project_action_ar.completedate}",{"$f":"IF(AND(AG16<>\"\",AH16=\"\"),IF($U16=\"NONE\",IF(AK16<>\"\",\"To do\",\"To come\"),\"\"),AH16)","v":"${actions.company_project_action_ar.company_project_answer}"},{"$f":"IF(AL16<>\"\",AL16,\"\")","v":"${actions.company_project_action_ar.completedate}"},{"$f":"IF(AG16=\"\",\"\",IF(AND($U16=\"NONE\",AK16=\"\"),Config!$B$6,IF(AH16<>\"\",IF(AK16-AL16>0,_xlfn.DAYS(AK16,AL16)&Config!$B$2,_xlfn.DAYS(AL16,AK16)&Config!$B$4),IF(AK16-REFERENCE_DATE>0,_xlfn.DAYS(AK16,REFERENCE_DATE)&Config!$B$3,IF($U16=\"NONE\",_xlfn.DAYS(REFERENCE_DATE,AK16)&Config!$B$5,\"\")))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AQ16<>\"\",\"X\",\"\")","v":"X"},"${company_project_stab}","${actions.company_project_action_stab.company_project_answer}","${actions.company_project_action_stab.company_project_comment}","${actions.company_project_action_stab.attachment_count}","${actions.company_project_action_stab.due_date}","${actions.company_project_action_stab.completedate}",{"$f":"IF(AND(AQ16<>\"\",AR16=\"\"),IF($U16=\"NONE\",IF(AU16<>\"\",\"To do\",\"To come\"),\"\"),AR16)","v":"${actions.company_project_action_stab.company_project_answer}"},{"$f":"IF(AV16<>\"\",AV16,\"\")","v":"${actions.company_project_action_stab.completedate}"},{"$f":"IF(AQ16=\"\",\"\",IF(AND($U16=\"NONE\",AU16=\"\"),Config!$B$6,IF(AR16<>\"\",IF(AU16-AV16>0,_xlfn.DAYS(AU16,AV16)&Config!$B$2,_xlfn.DAYS(AV16,AU16)&Config!$B$4),IF(AU16-REFERENCE_DATE>0,_xlfn.DAYS(AU16,REFERENCE_DATE)&Config!$B$3,IF($U16=\"NONE\",_xlfn.DAYS(REFERENCE_DATE,AU16)&Config!$B$5,\"\")))))","v":{"$error":"#VALUE!"}},{"$f":"IF(BA16<>\"\",\"X\",\"\")","v":"X"},"${company_project_mep}","${actions.company_project_action_mep.company_project_answer}","${actions.company_project_action_mep.company_project_comment}","${actions.company_project_action_mep.attachment_count}","${actions.company_project_action_mep.due_date}","${actions.company_project_action_mep.completedate}",{"$f":"IF(AND(BA16<>\"\",BB16=\"\"),IF($U16=\"NONE\",IF(BE16<>\"\",\"To do\",\"To come\"),\"\"),BB16)","v":"${actions.company_project_action_mep.company_project_answer}"},{"$f":"IF(BF16<>\"\",BF16,\"\")","v":"${actions.company_project_action_mep.completedate}"},{"$f":"IF(BA16=\"\",\"\",IF(AND($U16=\"NONE\",BE16=\"\"),Config!$B$6,IF(BB16<>\"\",IF(BE16-BF16>0,_xlfn.DAYS(BE16,BF16)&Config!$B$2,_xlfn.DAYS(BF16,BE16)&Config!$B$4),IF(BE16-REFERENCE_DATE>0,_xlfn.DAYS(BE16,REFERENCE_DATE)&Config!$B$3,IF($U16=\"NONE\",_xlfn.DAYS(REFERENCE_DATE,BE16)&Config!$B$5,\"\")))))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DS16<>\"\",\"X\",\"\")","v":"X"},"${company_project_pm}","${actions.company_project_action_pm.company_project_answer}","${actions.company_project_action_pm.company_project_comment}","${actions.company_project_action_pm.attachment_count}","${actions.company_project_action_pm.due_date}","${actions.company_project_action_pm.completedate}",{"$f":"IF(AND(DS16<>\"\",DT16=\"\"),IF($U16=\"NONE\",IF(DW16<>\"\",\"To do\",\"To come\"),\"\"),DT16)","v":"${actions.company_project_action_pm.company_project_answer}"},{"$f":"IF(DX16<>\"\",DX16,\"\")","v":"${actions.company_project_action_pm.completedate}"},{"$f":"IF(DS16=\"\",\"\",IF(AND($U16=\"NONE\",DW16=\"\"),Config!$B$6,IF(DT16<>\"\",IF(DW16-DX16>0,_xlfn.DAYS(DW16,DX16)&Config!$B$2,_xlfn.DAYS(DX16,DW16)&Config!$B$4),IF(DW16-REFERENCE_DATE>0,_xlfn.DAYS(DW16,REFERENCE_DATE)&Config!$B$3,IF($U16=\"NONE\",_xlfn.DAYS(REFERENCE_DATE,DW16)&Config!$B$5,\"\")))))","v":{"$error":"#VALUE!"}},null,{"$f":"COUNTA(DU16,DK16,DA16,CQ16,CG16,BW16,BM16,BC16,AS16,AI16)","v":4},{"$f":"IF(AND(DL16<>\"\",DL16<>\"0\"),1,0)+IF(AND(DV16<>\"\",DV16<>\"0\"),1,0)+IF(AND(DB16<>\"\",DB16<>\"0\"),1,0)+IF(AND(CR16<>\"\",CR16<>\"0\"),1,0)+IF(AND(CH16<>\"\",CH16<>\"0\"),1,0)+IF(AND(BX16<>\"\",BX16<>\"0\"),1,0)+IF(AND(BN16<>\"\",BN16<>\"0\"),1,0)+IF(AND(BD16<>\"\",BD16<>\"0\"),1,0)+IF(AND(AT16<>\"\",AT16<>\"0\"),1,0)+IF(AND(AJ16<>\"\",AJ16<>\"0\"),1,0)","v":4},{"$f":"IF(EC16<>0,EC16&\" comment(s) - \",\"\")&IF(ED16<>0,ED16&\" attachment(s)\",\"\")&CHAR(10)&\nIF(OR(EC16<>0,ED16<>0),\"Please, enlarge row height to view details\"&CHAR(10),\"\")&\nIF(AND(DR16<>\"\",DU16<>\"\"),\"[\"&$EA$13&\"] \"&DV16&\" attachment(s) - \"&DU16&CHAR(10),\"\")&\nIF(AND(CX16<>\"\",DA16<>\"\"),\"[\"&$DG$13&\"] \"&DB16&\" attachment(s) - \"&DA16&CHAR(10),\"\")&\nIF(AND(CN16<>\"\",CQ16<>\"\"),\"[\"&$CW$13&\"] \"&CR16&\" attachment(s) - \"&CQ16&CHAR(10),\"\")&\nIF(AND(CD16<>\"\",CG16<>\"\"),\"[\"&$CM$13&\"] \"&CH16&\" attachment(s) - \"&CG16&CHAR(10),\"\")&\nIF(AND(BT16<>\"\",BW16<>\"\"),\"[\"&$CC$13&\"] \"&BX16&\" attachment(s) - \"&BW16&CHAR(10),\"\")&\nIF(AND(BJ16<>\"\",BM16<>\"\"),\"[\"&$BS$13&\"] \"&BN16&\" attachment(s) - \"&BM16&CHAR(10),\"\")&\nIF(AND(AZ16<>\"\",BC16<>\"\"),\"[\"&$BI$13&\"] \"&BD16&\" attachment(s) - \"&BC16&CHAR(10),\"\")&\nIF(AND(AP16<>\"\",AS16<>\"\"),\"[\"&$AY$13&\"] \"&AT16&\" attachment(s) - \"&AS16&CHAR(10),\"\")&\nIF(AND(AF16<>\"\",AI16<>\"\"),\"[\"&$AO$13&\"] \"&AJ16&\" attachment(s) - \"&AI16&CHAR(10),\"\")&\nIF(AND(DH16<>\"\",DK16<>\"\"),\"[\"&$DQ$13&\"] \"&DL16&\" attachment(s) - \"&DK16&CHAR(10),\"\")","v":"4 comment(s) - 4 attachment(s)\nPlease, enlarge row height to view details\n[PM] ${actions.company_project_action_pm.attachment_count} attachment(s) - ${actions.company_project_action_pm.company_project_comment}\n[MPE] ${actions.company_project_action_mep.attachment_count} attachment(s) - ${actions.company_project_action_mep.company_project_comment}\n[STAB] ${actions.company_project_action_stab.attachment_count} attachment(s) - ${actions.company_project_action_stab.company_project_comment}\n[AR] ${actions.company_project_action_ar.attachment_count} attachment(s) - ${actions.company_project_action_ar.company_project_comment}\n"},"${listrow}"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$(_)","$(_)","$(_)"]

{"sheet":"Workflow Externe","index":1,"n_rows":9,"n_cols":19,"rows_kept":9,"cut":false,"hidden":true,"merged":[[1,1,1,18],[2,1,2,18],[6,1,8,1],[6,2,8,2],[6,3,8,3],[6,4,8,4],[6,5,8,5],[6,6,8,6],[6,7,8,7],[6,8,8,8],[6,12,7,16],[6,18,8,18],[6,9,8,9],[6,10,8,10],[6,11,8,11]]}
[]
[]
[]
[]
[]
[]
[null,"PROJECT","ORIGINATOR","PHASE","TRADE\nSUB TRADE","TYPE","ZONE","LEVEL","NUMBER","REVISION","TITLE","LIEN COOPERLINK","TRANSMISSION VERS LA SNCB\n(WORFLOW EXTERNE)",null,null,null,null,null,"COMMENTAIRE"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"DATE","DURÉE EXAMEN","ÉCHÉANCE","STATUT","DATE APPROB."]

{"sheet":"Config","index":2,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Dictionnary","Word","Description"]
["Days earlier","d earlier"]
["Days remaining","d left"]
["Days too late","d later"]
["Days overdued","d overdue"]
["Not yet planned","Not planned yet"]
["Contribute","Contrib."]
["Assigned","Assinged"]
["Status","Status"]
["Comment","Comment."]
["Attachment","Attach."]
["Deadline","Due date"]
["Approval date","Approval date"]
["Delay","Delay"]
["Link","Link"]
[]
["Statuses"]
["Positive","APPROUVE"]
["Negative","REFUSES"]
["None","IN PROGRESS -"]
["Aborted","ABORTED"]
["Previous","Obsolete"]
["Current","In force"]
[]
["Answers"]
["A","Approved"]
["B","Approved with comments"]
["C","Refuses"]
["D","Non concerned"]
["Undefined"]
["Undefined"]
["To do","Task open"]

{"sheet":"Generator","index":3,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[[7,0,7,9],[6,0,6,8]]}
[null,null,null,null,null,null,null,null,null,null,null,"Keyu Prefix","company_project",null,"Role title","Developer"]
[null,null,null,null,null,null,null,null,null,null,null,"Role","pm",null,"Company name"]
[null,null,null,null,null,null,null,null,null,null,null,"Displayed Role","pm"]
[null,null,null,null,null,null,null,null,null,null,null,"Answer Key Suffix","answer"]
[null,null,null,null,null,null,null,null,null,null,null,"Comment Key Suffix","comment"]
[]
[{"$f":"UPPER(\"Developer\")","v":"DEVELOPER"},null,null,null,null,null,null,null,null,{"$f":"UPPER(\"pm\")","v":"PM"}]
[{"$f":"UPPER(\"\")","v":""}]
[{"$f":"UPPER(Contribute&CHAR(10)&\"pm\")","v":"CONTRIB.\nPM"},{"$f":"UPPER(Assigned&CHAR(10)&\"pm\"&\" - CL\")","v":"ASSINGED\nPM - CL"},{"$f":"UPPER(Status&CHAR(10)&\"pm\"&\" - CL\")","v":"STATUS\nPM - CL"},{"$f":"UPPER(Comment&CHAR(10)&\"pm\"&\" - CL\")","v":"COMMENT.\nPM - CL"},{"$f":"UPPER(Attachment&CHAR(10)&\"pm\"&\" - CL\")","v":"ATTACH.\nPM - CL"},{"$f":"UPPER(Deadline&CHAR(10)&\"pm\"&\" - CL\")","v":"DUE DATE\nPM - CL"},{"$f":"UPPER(ApprovalDate&CHAR(10)&\"pm\"&\" - CL\")","v":"APPROVAL DATE\nPM - CL"},{"$f":"UPPER(Status&CHAR(10)&\"pm\")","v":"STATUS\nPM"},{"$f":"UPPER(ApprovalDate&CHAR(10)&\"pm\")","v":"APPROVAL DATE\nPM"},{"$f":"UPPER(Delay&CHAR(10)&\"Approb \"&CHAR(10)&\"pm\")","v":"DELAY\nAPPROB \nPM"}]
[{"$f":"IF(B10<>\"\",\"X\",\"\")","v":"X"},"${company_project_pm}","${actions.company_project_action_pm.company_project_answer}","${actions.company_project_action_pm.company_project_comment}","${actions.company_project_action_pm.attachment_count}","${actions.company_project_action_pm.due_date}","${actions.company_project_action_pm.completedate}",{"$f":"IF(AND(B10<>\"\",C10=\"\"),IF($U10=\"NONE\",IF(F10<>\"\",\"To do\",\"To come\"),\"\"),C10)","v":"${actions.company_project_action_pm.company_project_answer}"},{"$f":"IF(G10<>\"\",G10,\"\")","v":"${actions.company_project_action_pm.completedate}"},{"$f":"IF(B10=\"\",\"\",IF(AND($U10=\"NONE\",F10=\"\"),Config!$B$6,IF(C10<>\"\",IF(F10-G10>0,_xlfn.DAYS(F10,G10)&Config!$B$2,_xlfn.DAYS(G10,F10)&Config!$B$4),IF(F10-REFERENCE_DATE>0,_xlfn.DAYS(F10,REFERENCE_DATE)&Config!$B$3,IF($U10=\"NONE\",_xlfn.DAYS(REFERENCE_DATE,F10)&Config!$B$5,\"\")))))","v":{"$error":"#VALUE!"}}]